UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YxMQn8PXXNehEkeBef+j9RHv1HXQ7RSS6EAGCPL9nKw='
WHERE
key_id = 'f03f81545791e538cb45a183545637bb5e274919325f14f6f720c1d9de18884b'
AND (
token = 'YxMQn8PXXNehEkeBef+j9RHv1HXQ7RSS6EAGCPL9nKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)