UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9scQjsdYZyzpSV3JnJny93ipu4IF+4u2x+qvokylANA='
WHERE
key_id = '3d7ee62d3fb8cba50cfb9237b1596bab8657ef1b5f95f3c20d2c2a2d9ba66686'
AND (
token = '9scQjsdYZyzpSV3JnJny93ipu4IF+4u2x+qvokylANA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)