UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2ymKx+FpA96paagVPhWfuBdPUZOwLOe1n0UBTSjKD4g=' 
WHERE 
  key_id = 'f6109a3f6d74f04783c22b1654c4e2dcfeb60e6d472b9b53f09a5d086660d93a' 
  AND (
    token = '2ymKx+FpA96paagVPhWfuBdPUZOwLOe1n0UBTSjKD4g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043