UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gauO7wLIzZJMIoH881+rgYkbERFSbY1zKDyza7GmQr0='
WHERE
key_id = 'e08094ed3e97bc1d7d8276e7af58fe99f72e2a30e8207366036e71517c0df15b'
AND (
token = 'gauO7wLIzZJMIoH881+rgYkbERFSbY1zKDyza7GmQr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)