UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2W5n9pd36x6R0jiftTej99bF3rz1138ItkN+FI5yJ8='
WHERE
key_id = '02506c1c0bd6796b81ae3bacef1f62048d39e86c1b758d8276ae10b14a006b70'
AND (
token = 'C2W5n9pd36x6R0jiftTej99bF3rz1138ItkN+FI5yJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)