UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bKgi/Fk3f4hOsBSOJNf3vJv+5HFn0OWGeuK4humFC2k='
WHERE
key_id = 'b8a16cf80e97c091c3bf09ebaccbe531aeb1e9701e61d8e72fc23d80f947546b'
AND (
token = 'bKgi/Fk3f4hOsBSOJNf3vJv+5HFn0OWGeuK4humFC2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)