UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ria9n7Q7az2upeYWB7DmgHewiR5wqpz7O93jG8oouiI='
WHERE
key_id = '4e5f02d87a306810eea5dcdb5f138bc89a3050357f3a15264cc6395d4aafb7a4'
AND (
token = 'ria9n7Q7az2upeYWB7DmgHewiR5wqpz7O93jG8oouiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)