UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7il5dg42yrvG11sBW128yE0hnYX4dxtOMiXA88DSAU='
WHERE
key_id = '398e2f84eb6947544c37b827594438bb162f5bbe57631a19ee303211247d3a4b'
AND (
token = 'r7il5dg42yrvG11sBW128yE0hnYX4dxtOMiXA88DSAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)