UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TX+YzqsDu6FjOXrFvKmI8jSbRIIZJLB6d8nZjLozl7A='
WHERE
key_id = 'c24cb807dd146cba7cc62ef7b7a28c60804ab74740b6f765ece09e282acb6b9c'
AND (
token = 'TX+YzqsDu6FjOXrFvKmI8jSbRIIZJLB6d8nZjLozl7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)