UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xgvKN/U9bgTJ2ffTzDci29qwgfX5jYLj/3uy5QkT2zg=' 
WHERE 
  key_id = 'e97cc1c6463cd642504f6bea524aea0b0420d2f8d93073604df0e7b9a8ad7be0' 
  AND (
    token = 'xgvKN/U9bgTJ2ffTzDci29qwgfX5jYLj/3uy5QkT2zg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021