UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MwQiDEm0wvBRzAhGT1h+kXLrKNrlDhur9Xggu7aJ0E='
WHERE
key_id = '6c83223490a467e565c946f8fe8398cffa622a17bd2926b9dcf44b38a7ab6dca'
AND (
token = '8MwQiDEm0wvBRzAhGT1h+kXLrKNrlDhur9Xggu7aJ0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)