UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czqK+9av0vQxXZvgh3ktt9thstinIzTS6pTzAXFztf8='
WHERE
key_id = 'cf2a8a72b5a7896495eaa25a21847765340a5dd40ed5d9e8ea996aa2afdb9f31'
AND (
token = 'czqK+9av0vQxXZvgh3ktt9thstinIzTS6pTzAXFztf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)