UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVHdymWG5W3JZ1kilA1GU+QLK1fnGI8o5JENXRbZklw='
WHERE
key_id = 'e5d7fc7832e2341f413336c202b79c3b071f05acb4627fa8fffd9e76f2ea4ccd'
AND (
token = 'RVHdymWG5W3JZ1kilA1GU+QLK1fnGI8o5JENXRbZklw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)