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