UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tx89AbsU4d+86XQT+/Sy0yJDmVWhN+UtrDb9U3a29uE='
WHERE
key_id = '197b5c37e3e4301143baa36066246324655096ec00392e1ce5bcd713d93376f6'
AND (
token = 'tx89AbsU4d+86XQT+/Sy0yJDmVWhN+UtrDb9U3a29uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)