UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pq9r/KEZPg3E0YryOkf7W2s/gV+fSZHb0HAo27h3EwQ='
WHERE
key_id = '0c25640c3b65d00a7c18c16cb7a9c57099594d74ef6f5bcb7baada97ea0cc5dc'
AND (
token = 'Pq9r/KEZPg3E0YryOkf7W2s/gV+fSZHb0HAo27h3EwQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)