UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b+sU3vUUEexepf6nnsKr9iHmjspbas8r00k51PKJx/k='
WHERE
key_id = 'fd230edcbebc62fba95491acfab85e247911486d9a5a0fd7b5c4fa0a0b820b2c'
AND (
token = 'b+sU3vUUEexepf6nnsKr9iHmjspbas8r00k51PKJx/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)