UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l586H0WLxctSeZ1dIydTDAUpvkCm1J9aB8zDBZH3DhE='
WHERE
key_id = '7e1be6bdc4d63f19f2ba8f09ae043dd84873b1e85136b101d4285aac902bfd47'
AND (
token = 'l586H0WLxctSeZ1dIydTDAUpvkCm1J9aB8zDBZH3DhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)