UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XleN9W8CakqhAVjKCruZreUiMEc/1UK/vP3qzKBzgwM='
WHERE
key_id = 'c9b1548c8b13240af9d299ca3e37ee42dd9672391164ee14f8a0170a252f19a2'
AND (
token = 'XleN9W8CakqhAVjKCruZreUiMEc/1UK/vP3qzKBzgwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)