UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNNjDhfZa4rCtcY30vFmQI8Wcw9BiKhdy8SfNmukZZ0='
WHERE
key_id = 'b01f304f1eda01c16c2272e60f25995fbeeae20632005ecf06bb3bb8722857f7'
AND (
token = 'CNNjDhfZa4rCtcY30vFmQI8Wcw9BiKhdy8SfNmukZZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)