UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'es4BrVy3DftXutS84kJ96VAPBSWjOgQwA3bwnBxxtcw='
WHERE
key_id = '831256649529bea18d307d477d9184c8f2c3f8696b7a42107eca4cff9b7c7898'
AND (
token = 'es4BrVy3DftXutS84kJ96VAPBSWjOgQwA3bwnBxxtcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)