UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJbStfDiOElvjDRnXOy1O8IHMAK53KW03iPTbJyBMv0='
WHERE
key_id = '3d1007f1bad0987c54dc35fb8a98067c6384426a9a2c2dda31385e8cff856cf6'
AND (
token = 'zJbStfDiOElvjDRnXOy1O8IHMAK53KW03iPTbJyBMv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)