UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CkP9LrdgQiEASrdxkqPFJsFA4t8EVtNfwggYWOeeWbg='
WHERE
key_id = '1378e0e2b43d594a7c4ebf0da3af5e31058f378153a2b887f1b219279ccf0b30'
AND (
token = 'CkP9LrdgQiEASrdxkqPFJsFA4t8EVtNfwggYWOeeWbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)