UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YW8hmJ5WJdNt6CS3PwNb4sc0c9jh/Sh2wv72e4RwQrs='
WHERE
key_id = 'c41f4212d97529b812f124e19de9f8618beee3a5dcfe67724ff138c56a4d9446'
AND (
token = 'YW8hmJ5WJdNt6CS3PwNb4sc0c9jh/Sh2wv72e4RwQrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)