UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBjrFpUFa2tIVpBiYXIUejbYoxOHpLUix8cf5fSuwKk='
WHERE
key_id = 'ef9099b2f67fc1201a55b812f2443b6457276c0b6a1be409cb8a6d5071595ce7'
AND (
token = 'tBjrFpUFa2tIVpBiYXIUejbYoxOHpLUix8cf5fSuwKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)