UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pb/1NfQZXw0dzx2a90ne1FrYT8eKJdXumucUrQkz/AA='
WHERE
key_id = '8e712fe577b5d133b24d9fdbcea1afc3596304ebfcce39ad65883ca091960271'
AND (
token = 'pb/1NfQZXw0dzx2a90ne1FrYT8eKJdXumucUrQkz/AA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)