UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6slmLp1EkxfC5KfHX/f2k2Kqn0Q/emCUAkgAdw/JKAw='
WHERE
key_id = 'a3cda416e8c505af2c26144b31d73a677f86c6fd3218badd9b091d2269c9349a'
AND (
token = '6slmLp1EkxfC5KfHX/f2k2Kqn0Q/emCUAkgAdw/JKAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)