UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4z4BTX90+Rn0cacGSe3t9oRED+bE9zSRcyUI0Kkeu4='
WHERE
key_id = 'fe4593186f316e683b3954b85660984d8ec0e7e810c6fe148f9b8d334ee51de6'
AND (
token = 'd4z4BTX90+Rn0cacGSe3t9oRED+bE9zSRcyUI0Kkeu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)