UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/1dp/rG6dNEF8d/4jXXXk4pRLBh+XQBBvit3fRoixg='
WHERE
key_id = 'b23221cdbcff2b362c833ba0e3560a83b21018668f7313fb9dd5b5051b18775e'
AND (
token = 'H/1dp/rG6dNEF8d/4jXXXk4pRLBh+XQBBvit3fRoixg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)